delete from labsoft.bill where billno > 100001 limit 100000;
UPDATE `labsoft`.`bill` SET `BillNo`='100000',`cID`='500000' WHERE `BillNo`='100001';
ALTER TABLE `labsoft`.`bill` AUTO_INCREMENT = 100001 ;
delete from labsoft.billreceipt where billno > 0 limit 100000;
ALTER TABLE `labsoft`.`billreceipt` AUTO_INCREMENT = 1 ;
delete from labsoft.tests where billno > 0 limit 1000000;
ALTER TABLE `labsoft`.`tests` AUTO_INCREMENT = 1 ;
delete from labsoft.customer where cid > 500001 limit 100000;
UPDATE `labsoft`.`customer` SET `cID`='500000', `Name`='SHAMEEM NADUKKATTIL' WHERE `cID`='500001';
ALTER TABLE `labsoft`.`customer` AUTO_INCREMENT = 500001 ;
delete FROM labsoft.doctors where id > 0 limit 10000;
ALTER TABLE `labsoft`.`doctors` AUTO_INCREMENT = 1 ;
delete FROM labsoft.location where id > 0 limit 10000;
ALTER TABLE `labsoft`.`location` AUTO_INCREMENT = 1 ;
delete FROM labsoft.logs where id > 0 limit 10000;
ALTER TABLE `labsoft`.`logs` AUTO_INCREMENT = 1 ;
delete FROM labsoft.payments where id > 0 limit 10000;
ALTER TABLE `labsoft`.`payments` AUTO_INCREMENT = 1 ;
delete FROM labsoft.receipts where id > 0 limit 10000;
ALTER TABLE `labsoft`.`receipts` AUTO_INCREMENT = 1 ;
delete FROM labsoft.purchase where id > 0 limit 10000;
ALTER TABLE `labsoft`.`purchase` AUTO_INCREMENT = 1 ;
delete FROM labsoft.mpurchase where id > 0 limit 10000;
ALTER TABLE `labsoft`.`mpurchase` AUTO_INCREMENT = 1 ;
delete FROM labsoft.suppliers where id > 0 limit 10000;
ALTER TABLE `labsoft`.`suppliers` AUTO_INCREMENT = 1 ;
delete FROM labsoft.products where id > 0 limit 10000;
ALTER TABLE `labsoft`.`products` AUTO_INCREMENT = 1 ;